﻿CREATE TABLE [dbo].[InventoryAdjustmentMMC_history] (
    [InventoryAdjustmentMMCID]  BIGINT         NOT NULL,
    [InventoryAdjustmentTypeID] SMALLINT       NOT NULL,
    [InventoryItemByVendorID]   BIGINT         NOT NULL,
    [oldquant]                  NUMERIC (8, 2) NOT NULL,
    [newquant]                  NUMERIC (8, 2) NOT NULL,
    [userUpdatedID]             INT            NOT NULL,
    [dateUpdated]               DATETIME       NOT NULL,
    [notes]                     NVARCHAR (500) NULL
);

